#!/usr/bin/env python
# -*- encoding: utf-8 -*-
# Project: spd-sxmcc
"""
@file: Select.py
@author: lyndon
@time: Created on 2021-01-15 10:36
@env: Python
@desc:
@ref:
@blog:
"""
from sqlalchemy.orm import sessionmaker
from db.sqlalchemy1322.Engine import engine, CustmGrpBasInfo

Session = sessionmaker(bind=engine)
session = Session()


if __name__ == '__main__':
    a = session.query(CustmGrpBasInfo).all()
    for d in a:
        outStr = "id: %s custm_grp_name:%s -> (custm_grp_desc: %s,domain: %s, model_express: %s)" % (d.id, d.custm_grp_name, d.custm_grp_desc, d.domain, d.model_express)
        print(outStr)

